oracle表空间的创建 |
您所在的位置:网站首页 › oracle 表空间不足解决办法大全 › oracle表空间的创建 |
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "SYSTEM"ALTER DATABASE TEMPFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/TEMP01.DBF' RESIZE 200MALTER DATABASE TEMPFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/TEMP01.DBF' AUTOEXTEND OFF
CREATE BIGFILE TABLESPACE "APPTBL" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/APPTBL01.DBF' SIZE 1024M AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'APPTBL'); END;
CREATE USER SWIFTS PROFILE DEFAULT IDENTIFIED BY SWIFTS DEFAULT TABLESPACE APPTBL TEMPORARY TABLESPACE TEMP ;GRANT "CONNECT" TO "SWIFTS"GRANT RESOURCE TO SWIFTS ;ALTER USER "SWIFTS" QUOTA UNLIMITED ON "AOTOCRE_TBL" QUOTA UNLIMITED ON "APPTBL" QUOTA 0 K ON "BASEDATA" QUOTA UNLIMITED ON "BATCHDATA" QUOTA UNLIMITED ON "QUERY_TBL" QUOTA UNLIMITED ON "TEMP"ALTER USER "SWIFTS" QUOTA UNLIMITED ON "BASEDATA" QUOTA UNLIMITED ON "INDX_TBL"
CREATE BIGFILE TABLESPACE "BASEDATA" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/BASEDATA01.DBF' SIZE 2048M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'BASEDATA'); END;
CREATE BIGFILE TABLESPACE "BATCHDATA" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/BATCHDATA01.DBF' SIZE 4096M AUTOEXTEND ON NEXT 2048M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'BATCHDATA'); END;
CREATE BIGFILE TABLESPACE "QUERY_TBL" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/QUERY_TBL01.DBF' SIZE 4096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'QUERY_TBL'); END;
CREATE BIGFILE TABLESPACE "AOTOCRE_TBL" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/AOTOCRE_TBL01.DBF' SIZE 4096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'AOTOCRE_TBL'); END;
CREATE BIGFILE TABLESPACE "INDX_DEF" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/INDX_DEF01.DBF' SIZE 4096M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'INDX_DEF'); END; CREATE BIGFILE TABLESPACE "INDX_TBL" DATAFILE 'F:/ORACLE/PRODUCT/10.1.0/ORADATA/ORCL/INDX_TBL01.DBF' SIZE 4096M AUTOEXTEND ON NEXT 2048M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'INDX_TBL'); END; |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |